inherited frmPosSalePriceBill: TfrmPosSalePriceBill
  Caption = 'POS'#38480#26102#20419#38144#20215#26684
  PixelsPerInch = 96
  TextHeight = 12
  inherited pnlDBCtrl: TPanel
    inherited pnlThirdtrade: TPanel
      inherited edtTTtraderid: TcxDBLookupComboBox
        ExplicitHeight = 21
      end
      inherited lblTTtraderid: TcxLabel
        AnchorX = 78
      end
      inherited cxLabel1: TcxLabel
        AnchorX = 263
      end
      inherited edtTTamount: TcxDBCalcEdit
        ExplicitHeight = 21
      end
      inherited edtTTremark: TcxDBTextEdit
        ExplicitHeight = 21
      end
      inherited edtTTBalanceid: TcxDBLookupComboBox
        ExplicitHeight = 21
      end
      inherited edtTTAccountid: TcxDBLookupComboBox
        ExplicitHeight = 21
      end
      inherited lblTTBalanceid: TcxLabel
        AnchorX = 471
      end
      inherited edtTTBalanceamt: TcxDBCalcEdit
        ExplicitHeight = 21
      end
    end
    inherited lblName: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited edtDate: TcxDBDateEdit
      ExplicitHeight = 21
    end
    inherited edtCode: TcxDBTextEdit
      ExplicitHeight = 21
    end
    inherited DtlPageCtrl: TcxPageControl
      TabOrder = 7
      inherited tabMain: TcxTabSheet
        ExplicitWidth = 0
        ExplicitHeight = 0
        inherited DtlGrid: TcxGrid
          inherited DtlGridDBTableView: TcxGridDBBandedTableView
            inherited colQuantity: TcxGridDBBandedColumn
              Visible = False
            end
          end
        end
      end
      inherited tsSum: TcxTabSheet
        ExplicitWidth = 872
        ExplicitHeight = 258
      end
    end
    inherited edtCreate_time: TcxDBTimeEdit
      ExplicitHeight = 21
    end
    inherited imgCheck: TcxImage
      TabOrder = 5
    end
    inherited lblPrinted: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited dynlblCreate_by: TcxLabel
      AnchorX = 221
    end
    inherited dynedtCreate_by: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblCheck_by: TcxLabel
      AnchorX = 429
    end
    inherited dynedtCheck_by: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblFilid: TcxLabel
      AnchorX = 88
    end
    inherited dynedtFilid: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblDeptid: TcxLabel
      AnchorX = 301
    end
    inherited dynedtDeptid: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblEmpid: TcxLabel
      AnchorX = 505
    end
    inherited dynedtEmpid: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblBKind: TcxLabel
      AnchorX = 149
    end
    inherited dynedtBKind: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
  end
  inherited Panel1: TPanel
    inherited labFuncName: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited labFuncDesc: TcxLabel
      Style.IsFontAssigned = True
    end
  end
  inherited pnlTop: TPanel
    inherited edtPrint: TcxLookupComboBox
      ExplicitHeight = 21
    end
  end
  inherited pnlBottom: TPanel
    inherited lblDepotQty: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited barBill: TcxProgressBar
      ExplicitHeight = 21
    end
  end
  inherited cxStyleRepository1: TcxStyleRepository
    PixelsPerInch = 96
    inherited cxGridBandedTableViewStyleSheet1: TcxGridBandedTableViewStyleSheet
      BuiltIn = True
    end
  end
  inherited qryDetail: TUniQuery
    SQLInsert.Strings = (
      'INSERT INTO tb_possalepricedtl'
      
        '  (bid, bno, productid, unitid, price, newprice, pause, custom1,' +
        ' custom2, custom3, custom4, custom5, custom6, custom7, custom8, ' +
        'custom9, custom10, custom11, custom12, custom13, custom14, custo' +
        'm15, explan, traderid, length, width, height)'
      'VALUES'
      
        '  (:bid, :bno, :productid, :unitid, :price, :newprice, :pause, :' +
        'custom1, :custom2, :custom3, :custom4, :custom5, :custom6, :cust' +
        'om7, :custom8, :custom9, :custom10, :custom11, :custom12, :custo' +
        'm13, :custom14, :custom15, :explan, :traderid, :length, :width, ' +
        ':height)')
    SQLDelete.Strings = (
      'DELETE FROM tb_possalepricedtl'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLUpdate.Strings = (
      'UPDATE tb_possalepricedtl'
      'SET'
      
        '  bid = :bid, bno = :bno, productid = :productid, unitid = :unit' +
        'id, price = :price, newprice = :newprice, pause = :pause, custom' +
        '1 = :custom1, custom2 = :custom2, custom3 = :custom3, custom4 = ' +
        ':custom4, custom5 = :custom5, custom6 = :custom6, custom7 = :cus' +
        'tom7, custom8 = :custom8, custom9 = :custom9, custom10 = :custom' +
        '10, custom11 = :custom11, custom12 = :custom12, custom13 = :cust' +
        'om13, custom14 = :custom14, custom15 = :custom15, explan = :expl' +
        'an, traderid = :traderid, length = :length, width = :width, heig' +
        'ht = :height'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLLock.Strings = (
      'SELECT * FROM tb_possalepricedtl'
      'WITH (UPDLOCK, ROWLOCK, HOLDLOCK)'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLRefresh.Strings = (
      
        'SELECT bid, bno, productid, unitid, price, newprice, pause, cust' +
        'om1, custom2, custom3, custom4, custom5, custom6, custom7, custo' +
        'm8, custom9, custom10, custom11, custom12, custom13, custom14, c' +
        'ustom15, explan, traderid, length, width, height FROM tb_possale' +
        'pricedtl'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLRecCount.Strings = (
      'SET :PCOUNT = (SELECT COUNT(*) FROM tb_possalepricedtl'
      ')')
    Connection = MainDM.UniConn
    SQL.Strings = (
      'select * from tb_possalepricedtl')
  end
  inherited MainDataSet: TUniQuery
    SQLInsert.Strings = (
      'INSERT INTO tb_possaleprice'
      
        '  (bid, bkind, bstate, bcode, bdate, filid, empid, create_by, ch' +
        'eck_by, deptid, accountid, credid, adjuctrate, isround, begdate,' +
        ' enddate, begtime, endtime, printtmpltid, pause, custom1, custom' +
        '2, custom3, custom4, custom5, custom6, custom7, custom8, custom9' +
        ', custom10, custom11, custom12, custom13, custom14, custom15, cr' +
        'eate_time, update_time, remark, sflag, depotid, scorerate, check' +
        '_time)'
      'VALUES'
      
        '  (:bid, :bkind, :bstate, :bcode, :bdate, :filid, :empid, :creat' +
        'e_by, :check_by, :deptid, :accountid, :credid, :adjuctrate, :isr' +
        'ound, :begdate, :enddate, :begtime, :endtime, :printtmpltid, :pa' +
        'use, :custom1, :custom2, :custom3, :custom4, :custom5, :custom6,' +
        ' :custom7, :custom8, :custom9, :custom10, :custom11, :custom12, ' +
        ':custom13, :custom14, :custom15, :create_time, :update_time, :re' +
        'mark, :sflag, :depotid, :scorerate, :check_time)')
    SQLDelete.Strings = (
      'DELETE FROM tb_possaleprice'
      'WHERE'
      '  bid = :Old_bid')
    SQLUpdate.Strings = (
      'UPDATE tb_possaleprice'
      'SET'
      
        '  bid = :bid, bkind = :bkind, bstate = :bstate, bcode = :bcode, ' +
        'bdate = :bdate, filid = :filid, empid = :empid, create_by = :cre' +
        'ate_by, check_by = :check_by, deptid = :deptid, accountid = :acc' +
        'ountid, credid = :credid, adjuctrate = :adjuctrate, isround = :i' +
        'sround, begdate = :begdate, enddate = :enddate, begtime = :begti' +
        'me, endtime = :endtime, printtmpltid = :printtmpltid, pause = :p' +
        'ause, custom1 = :custom1, custom2 = :custom2, custom3 = :custom3' +
        ', custom4 = :custom4, custom5 = :custom5, custom6 = :custom6, cu' +
        'stom7 = :custom7, custom8 = :custom8, custom9 = :custom9, custom' +
        '10 = :custom10, custom11 = :custom11, custom12 = :custom12, cust' +
        'om13 = :custom13, custom14 = :custom14, custom15 = :custom15, cr' +
        'eate_time = :create_time, update_time = :update_time, remark = :' +
        'remark, sflag = :sflag, depotid = :depotid, scorerate = :scorera' +
        'te, check_time = :check_time'
      'WHERE'
      '  bid = :Old_bid')
    SQLLock.Strings = (
      'SELECT * FROM tb_possaleprice'
      'WITH (UPDLOCK, ROWLOCK, HOLDLOCK)'
      'WHERE'
      '  bid = :Old_bid')
    SQLRefresh.Strings = (
      
        'SELECT bid, bkind, bstate, bcode, bdate, filid, empid, create_by' +
        ', check_by, deptid, accountid, credid, adjuctrate, isround, begd' +
        'ate, enddate, begtime, endtime, printtmpltid, pause, custom1, cu' +
        'stom2, custom3, custom4, custom5, custom6, custom7, custom8, cus' +
        'tom9, custom10, custom11, custom12, custom13, custom14, custom15' +
        ', create_time, update_time, remark, sflag, depotid, scorerate, c' +
        'heck_time FROM tb_possaleprice'
      'WHERE'
      '  bid = :Old_bid')
    SQLRecCount.Strings = (
      'SET :PCOUNT = (SELECT COUNT(*) FROM tb_possaleprice'
      ')')
    Connection = MainDM.UniConn
    SQL.Strings = (
      'select * from tb_possaleprice')
  end
end
